Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 4320 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 472.6 KiB |
| Average record size in memory | 112.0 B |
Variable types
| Numeric | 14 |
|---|
lifetime is highly overall correlated with purchase_count | High correlation |
recency is highly overall correlated with avg_purchase_interval and 2 other fields | High correlation |
avg_purchase_interval is highly overall correlated with recency and 2 other fields | High correlation |
frequency is highly overall correlated with recency and 2 other fields | High correlation |
number_products is highly overall correlated with nunique_products and 2 other fields | High correlation |
nunique_products is highly overall correlated with number_products and 2 other fields | High correlation |
avg_basket_size is highly overall correlated with avg_order_value and 1 other fields | High correlation |
purchase_count is highly overall correlated with lifetime and 8 other fields | High correlation |
charge_back_count is highly overall correlated with purchase_count and 1 other fields | High correlation |
return_rate is highly overall correlated with purchase_count and 1 other fields | High correlation |
avg_order_value is highly overall correlated with avg_basket_size and 1 other fields | High correlation |
gross_revenue is highly overall correlated with number_products and 4 other fields | High correlation |
avg_unt_price is highly skewed (γ1 = 36.54224156) | Skewed |
gross_revenue is highly skewed (γ1 = 21.5077176) | Skewed |
customer_id has unique values | Unique |
charge_back_count has 2828 (65.5%) zeros | Zeros |
return_rate has 2828 (65.5%) zeros | Zeros |
Reproduction
| Analysis started | 2023-05-29 18:33:12.610778 |
|---|---|
| Analysis finished | 2023-05-29 18:33:46.608470 |
| Duration | 34 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
| Distinct | 4320 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15300.771 |
| Minimum | 12347 |
|---|---|
| Maximum | 18287 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 12347 |
|---|---|
| 5-th percentile | 12617.95 |
| Q1 | 13815.75 |
| median | 15299.5 |
| Q3 | 16778.25 |
| 95-th percentile | 17980.2 |
| Maximum | 18287 |
| Range | 5940 |
| Interquartile range (IQR) | 2962.5 |
Descriptive statistics
| Standard deviation | 1720.2179 |
|---|---|
| Coefficient of variation (CV) | 0.11242688 |
| Kurtosis | -1.1947082 |
| Mean | 15300.771 |
| Median Absolute Deviation (MAD) | 1481 |
| Skewness | 0.0010717092 |
| Sum | 66099331 |
| Variance | 2959149.6 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17850 | 1 | < 0.1% |
| 15280 | 1 | < 0.1% |
| 15700 | 1 | < 0.1% |
| 17299 | 1 | < 0.1% |
| 12837 | 1 | < 0.1% |
| 15076 | 1 | < 0.1% |
| 17444 | 1 | < 0.1% |
| 15921 | 1 | < 0.1% |
| 15747 | 1 | < 0.1% |
| 15840 | 1 | < 0.1% |
| Other values (4310) | 4310 |
| Value | Count | Frequency (%) |
| 12347 | 1 | |
| 12348 | 1 | |
| 12349 | 1 | |
| 12350 | 1 | |
| 12352 | 1 | |
| 12353 | 1 | |
| 12354 | 1 | |
| 12355 | 1 | |
| 12356 | 1 | |
| 12357 | 1 |
| Value | Count | Frequency (%) |
| 18287 | 1 | |
| 18283 | 1 | |
| 18282 | 1 | |
| 18281 | 1 | |
| 18280 | 1 | |
| 18278 | 1 | |
| 18277 | 1 | |
| 18276 | 1 | |
| 18273 | 1 | |
| 18272 | 1 |
lifetime
Real number (ℝ)
| Distinct | 305 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 223.07708 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 113 |
| median | 249 |
| Q3 | 326 |
| 95-th percentile | 371 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 213 |
Descriptive statistics
| Standard deviation | 117.7561 |
|---|---|
| Coefficient of variation (CV) | 0.52787178 |
| Kurtosis | -1.2272183 |
| Mean | 223.07708 |
| Median Absolute Deviation (MAD) | 102 |
| Skewness | -0.36980487 |
| Sum | 963693 |
| Variance | 13866.499 |
| Monotonicity | Decreasing |
| Value | Count | Frequency (%) |
| 373 | 95 | 2.2% |
| 372 | 91 | 2.1% |
| 366 | 83 | 1.9% |
| 368 | 70 | 1.6% |
| 369 | 69 | 1.6% |
| 365 | 67 | 1.6% |
| 358 | 58 | 1.3% |
| 367 | 50 | 1.2% |
| 371 | 46 | 1.1% |
| 359 | 42 | 1.0% |
| Other values (295) | 3649 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 4 | 0.1% |
| 2 | 5 | |
| 3 | 9 | |
| 4 | 7 | |
| 5 | 5 | |
| 7 | 6 | |
| 8 | 3 | 0.1% |
| 9 | 5 | |
| 10 | 12 |
| Value | Count | Frequency (%) |
| 373 | 95 | |
| 372 | 91 | |
| 371 | 46 | |
| 369 | 69 | |
| 368 | 70 | |
| 367 | 50 | |
| 366 | 83 | |
| 365 | 67 | |
| 364 | 40 | |
| 362 | 31 | 0.7% |
recency
Real number (ℝ)
| Distinct | 304 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 92.013657 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 35 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 17 |
| median | 50 |
| Q3 | 142 |
| 95-th percentile | 311 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 125 |
Descriptive statistics
| Standard deviation | 100.06908 |
|---|---|
| Coefficient of variation (CV) | 1.0875459 |
| Kurtosis | 0.43240872 |
| Mean | 92.013657 |
| Median Absolute Deviation (MAD) | 40 |
| Skewness | 1.2467806 |
| Sum | 397499 |
| Variance | 10013.82 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 103 | 2.4% |
| 4 | 94 | 2.2% |
| 3 | 94 | 2.2% |
| 2 | 90 | 2.1% |
| 8 | 79 | 1.8% |
| 10 | 77 | 1.8% |
| 17 | 74 | 1.7% |
| 7 | 71 | 1.6% |
| 9 | 70 | 1.6% |
| 22 | 64 | 1.5% |
| Other values (294) | 3504 |
| Value | Count | Frequency (%) |
| 0 | 35 | 0.8% |
| 1 | 103 | |
| 2 | 90 | |
| 3 | 94 | |
| 4 | 94 | |
| 5 | 48 | |
| 7 | 71 | |
| 8 | 79 | |
| 9 | 70 | |
| 10 | 77 |
| Value | Count | Frequency (%) |
| 373 | 17 | |
| 372 | 17 | |
| 371 | 6 | 0.1% |
| 369 | 3 | 0.1% |
| 368 | 5 | 0.1% |
| 367 | 5 | 0.1% |
| 366 | 10 | |
| 365 | 10 | |
| 364 | 6 | 0.1% |
| 362 | 6 | 0.1% |
avg_purchase_interval
Real number (ℝ)
| Distinct | 1402 |
|---|---|
| Distinct (%) | 32.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.597846 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 11.736549 |
| Q1 | 31 |
| median | 60 |
| Q3 | 119 |
| 95-th percentile | 289.05 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 88 |
Descriptive statistics
| Standard deviation | 84.740189 |
|---|---|
| Coefficient of variation (CV) | 0.94578377 |
| Kurtosis | 2.0189487 |
| Mean | 89.597846 |
| Median Absolute Deviation (MAD) | 34 |
| Skewness | 1.6162457 |
| Sum | 387062.7 |
| Variance | 7180.8996 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 53 | 31 | 0.7% |
| 30 | 26 | 0.6% |
| 25 | 23 | 0.5% |
| 106 | 21 | 0.5% |
| 18 | 21 | 0.5% |
| 64 | 20 | 0.5% |
| 23 | 19 | 0.4% |
| 29 | 19 | 0.4% |
| 43 | 19 | 0.4% |
| 92 | 18 | 0.4% |
| Other values (1392) | 4103 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 0.6666666667 | 1 | < 0.1% |
| 1 | 5 | |
| 1.534979424 | 1 | < 0.1% |
| 1.718894009 | 1 | < 0.1% |
| 2 | 3 | |
| 2.207100592 | 1 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 2.5 | 1 | < 0.1% |
| 2.96031746 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 373 | 15 | |
| 372 | 14 | |
| 371 | 5 | 0.1% |
| 369 | 1 | < 0.1% |
| 368 | 4 | 0.1% |
| 367 | 5 | 0.1% |
| 366 | 6 | 0.1% |
| 365 | 8 | |
| 364 | 5 | 0.1% |
| 362 | 6 | 0.1% |
frequency
Real number (ℝ)
| Distinct | 1402 |
|---|---|
| Distinct (%) | 32.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.029348771 |
| Minimum | 0 |
|---|---|
| Maximum | 1.5 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0034482759 |
| Q1 | 0.0084033613 |
| median | 0.016666667 |
| Q3 | 0.032258065 |
| 95-th percentile | 0.085110323 |
| Maximum | 1.5 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.023854703 |
Descriptive statistics
| Standard deviation | 0.056479631 |
|---|---|
| Coefficient of variation (CV) | 1.9244292 |
| Kurtosis | 219.29335 |
| Mean | 0.029348771 |
| Median Absolute Deviation (MAD) | 0.0098820059 |
| Skewness | 12.05582 |
| Sum | 126.78669 |
| Variance | 0.0031899487 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.01886792453 | 31 | 0.7% |
| 0.03333333333 | 26 | 0.6% |
| 0.04 | 23 | 0.5% |
| 0.009433962264 | 21 | 0.5% |
| 0.05555555556 | 21 | 0.5% |
| 0.015625 | 20 | 0.5% |
| 0.04347826087 | 19 | 0.4% |
| 0.03448275862 | 19 | 0.4% |
| 0.02325581395 | 19 | 0.4% |
| 0.01086956522 | 18 | 0.4% |
| Other values (1392) | 4103 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 0.002680965147 | 15 | |
| 0.002688172043 | 14 | |
| 0.00269541779 | 5 | 0.1% |
| 0.0027100271 | 1 | < 0.1% |
| 0.002717391304 | 4 | 0.1% |
| 0.00272479564 | 5 | 0.1% |
| 0.002732240437 | 6 | 0.1% |
| 0.002739726027 | 8 | |
| 0.002747252747 | 5 | 0.1% |
| Value | Count | Frequency (%) |
| 1.5 | 1 | < 0.1% |
| 1 | 5 | |
| 0.6514745308 | 1 | < 0.1% |
| 0.581769437 | 1 | < 0.1% |
| 0.5 | 3 | 0.1% |
| 0.4530831099 | 1 | < 0.1% |
| 0.4444444444 | 1 | < 0.1% |
| 0.4 | 1 | < 0.1% |
| 0.3378016086 | 1 | < 0.1% |
| 0.3333333333 | 10 |
number_products
Real number (ℝ)
| Distinct | 468 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.728241 |
| Minimum | 1 |
|---|---|
| Maximum | 7838 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 17 |
| median | 41 |
| Q3 | 100 |
| 95-th percentile | 315.05 |
| Maximum | 7838 |
| Range | 7837 |
| Interquartile range (IQR) | 83 |
Descriptive statistics
| Standard deviation | 228.81283 |
|---|---|
| Coefficient of variation (CV) | 2.4944643 |
| Kurtosis | 482.47675 |
| Mean | 91.728241 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 18.091345 |
| Sum | 396266 |
| Variance | 52355.309 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 85 | 2.0% |
| 6 | 77 | 1.8% |
| 9 | 75 | 1.7% |
| 1 | 70 | 1.6% |
| 15 | 69 | 1.6% |
| 11 | 68 | 1.6% |
| 8 | 67 | 1.6% |
| 5 | 66 | 1.5% |
| 7 | 65 | 1.5% |
| 28 | 65 | 1.5% |
| Other values (458) | 3613 |
| Value | Count | Frequency (%) |
| 1 | 70 | |
| 2 | 50 | |
| 3 | 56 | |
| 4 | 48 | |
| 5 | 66 | |
| 6 | 77 | |
| 7 | 65 | |
| 8 | 67 | |
| 9 | 75 | |
| 10 | 85 |
| Value | Count | Frequency (%) |
| 7838 | 1 | |
| 5673 | 1 | |
| 5095 | 1 | |
| 4580 | 1 | |
| 2698 | 1 | |
| 2379 | 1 | |
| 2060 | 1 | |
| 1818 | 1 | |
| 1673 | 1 | |
| 1637 | 1 |
nunique_products
Real number (ℝ)
| Distinct | 341 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.584954 |
| Minimum | 1 |
|---|---|
| Maximum | 1786 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 16 |
| median | 35 |
| Q3 | 77.25 |
| 95-th percentile | 204 |
| Maximum | 1786 |
| Range | 1785 |
| Interquartile range (IQR) | 61.25 |
Descriptive statistics
| Standard deviation | 85.403084 |
|---|---|
| Coefficient of variation (CV) | 1.3867524 |
| Kurtosis | 99.614722 |
| Mean | 61.584954 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 6.9167284 |
| Sum | 266047 |
| Variance | 7293.6867 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 91 | 2.1% |
| 10 | 85 | 2.0% |
| 8 | 80 | 1.9% |
| 9 | 79 | 1.8% |
| 11 | 76 | 1.8% |
| 13 | 76 | 1.8% |
| 6 | 73 | 1.7% |
| 5 | 72 | 1.7% |
| 15 | 72 | 1.7% |
| 14 | 72 | 1.7% |
| Other values (331) | 3544 |
| Value | Count | Frequency (%) |
| 1 | 91 | |
| 2 | 51 | |
| 3 | 60 | |
| 4 | 51 | |
| 5 | 72 | |
| 6 | 73 | |
| 7 | 71 | |
| 8 | 80 | |
| 9 | 79 | |
| 10 | 85 |
| Value | Count | Frequency (%) |
| 1786 | 1 | |
| 1766 | 1 | |
| 1322 | 1 | |
| 1118 | 1 | |
| 884 | 1 | |
| 817 | 1 | |
| 717 | 1 | |
| 714 | 1 | |
| 699 | 1 | |
| 636 | 1 |
avg_basket_size
Real number (ℝ)
| Distinct | 2243 |
|---|---|
| Distinct (%) | 51.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 200.08462 |
| Minimum | 0.25 |
|---|---|
| Maximum | 7824 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0.25 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 80 |
| median | 140 |
| Q3 | 236.15833 |
| 95-th percentile | 524.01667 |
| Maximum | 7824 |
| Range | 7823.75 |
| Interquartile range (IQR) | 156.15833 |
Descriptive statistics
| Standard deviation | 269.78265 |
|---|---|
| Coefficient of variation (CV) | 1.3483427 |
| Kurtosis | 193.52202 |
| Mean | 200.08462 |
| Median Absolute Deviation (MAD) | 70.630682 |
| Skewness | 10.017756 |
| Sum | 864365.58 |
| Variance | 72782.679 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 120 | 19 | 0.4% |
| 72 | 18 | 0.4% |
| 64 | 17 | 0.4% |
| 144 | 16 | 0.4% |
| 136 | 16 | 0.4% |
| 44 | 16 | 0.4% |
| 60 | 15 | 0.3% |
| 146 | 15 | 0.3% |
| 100 | 15 | 0.3% |
| 88 | 15 | 0.3% |
| Other values (2233) | 4158 |
| Value | Count | Frequency (%) |
| 0.25 | 1 | < 0.1% |
| 0.6666666667 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 2 | 4 | |
| 3 | 4 | |
| 3.333333333 | 1 | < 0.1% |
| 4 | 7 | |
| 5 | 3 | |
| 5.25 | 1 | < 0.1% |
| 5.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7824 | 1 | |
| 4300 | 1 | |
| 4280 | 1 | |
| 3206.083333 | 1 | |
| 3028 | 1 | |
| 2924 | 1 | |
| 2880 | 1 | |
| 2708 | 1 | |
| 2692.547945 | 1 | |
| 2529 | 1 |
purchase_count
Real number (ℝ)
| Distinct | 63 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.0310185 |
| Minimum | 1 |
|---|---|
| Maximum | 243 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 16 |
| Maximum | 243 |
| Range | 242 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 9.1323251 |
|---|---|
| Coefficient of variation (CV) | 1.815204 |
| Kurtosis | 222.19401 |
| Mean | 5.0310185 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 11.431686 |
| Sum | 21734 |
| Variance | 83.399362 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1301 | |
| 2 | 800 | |
| 3 | 488 | 11.3% |
| 4 | 381 | 8.8% |
| 5 | 282 | 6.5% |
| 6 | 195 | 4.5% |
| 7 | 152 | 3.5% |
| 8 | 117 | 2.7% |
| 9 | 80 | 1.9% |
| 10 | 73 | 1.7% |
| Other values (53) | 451 | 10.4% |
| Value | Count | Frequency (%) |
| 1 | 1301 | |
| 2 | 800 | |
| 3 | 488 | 11.3% |
| 4 | 381 | 8.8% |
| 5 | 282 | 6.5% |
| 6 | 195 | 4.5% |
| 7 | 152 | 3.5% |
| 8 | 117 | 2.7% |
| 9 | 80 | 1.9% |
| 10 | 73 | 1.7% |
| Value | Count | Frequency (%) |
| 243 | 1 | |
| 217 | 1 | |
| 169 | 1 | |
| 126 | 1 | |
| 118 | 2 | |
| 88 | 1 | |
| 75 | 1 | |
| 73 | 1 | |
| 66 | 1 | |
| 65 | 1 |
charge_back_count
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.77199074 |
| Minimum | 0 |
|---|---|
| Maximum | 45 |
| Zeros | 2828 |
| Zeros (%) | 65.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.9735699 |
|---|---|
| Coefficient of variation (CV) | 2.5564684 |
| Kurtosis | 151.42598 |
| Mean | 0.77199074 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.1742875 |
| Sum | 3335 |
| Variance | 3.8949782 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2828 | |
| 1 | 839 | 19.4% |
| 2 | 288 | 6.7% |
| 3 | 139 | 3.2% |
| 4 | 92 | 2.1% |
| 5 | 37 | 0.9% |
| 6 | 32 | 0.7% |
| 7 | 21 | 0.5% |
| 9 | 8 | 0.2% |
| 10 | 5 | 0.1% |
| Other values (13) | 31 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 2828 | |
| 1 | 839 | 19.4% |
| 2 | 288 | 6.7% |
| 3 | 139 | 3.2% |
| 4 | 92 | 2.1% |
| 5 | 37 | 0.9% |
| 6 | 32 | 0.7% |
| 7 | 21 | 0.5% |
| 8 | 5 | 0.1% |
| 9 | 8 | 0.2% |
| Value | Count | Frequency (%) |
| 45 | 1 | < 0.1% |
| 44 | 1 | < 0.1% |
| 35 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 1 | < 0.1% |
| 15 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 5 |
return_rate
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 143 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.099820228 |
| Minimum | 0 |
|---|---|
| Maximum | 0.75 |
| Zeros | 2828 |
| Zeros (%) | 65.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.2 |
| 95-th percentile | 0.5 |
| Maximum | 0.75 |
| Range | 0.75 |
| Interquartile range (IQR) | 0.2 |
Descriptive statistics
| Standard deviation | 0.16131425 |
|---|---|
| Coefficient of variation (CV) | 1.6160478 |
| Kurtosis | 1.0390432 |
| Mean | 0.099820228 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.4736402 |
| Sum | 431.22338 |
| Variance | 0.026022289 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2828 | |
| 0.5 | 234 | 5.4% |
| 0.3333333333 | 211 | 4.9% |
| 0.25 | 165 | 3.8% |
| 0.2 | 139 | 3.2% |
| 0.1666666667 | 78 | 1.8% |
| 0.1428571429 | 61 | 1.4% |
| 0.4 | 55 | 1.3% |
| 0.125 | 46 | 1.1% |
| 0.2857142857 | 40 | 0.9% |
| Other values (133) | 463 | 10.7% |
| Value | Count | Frequency (%) |
| 0 | 2828 | |
| 0.01369863014 | 1 | < 0.1% |
| 0.02222222222 | 1 | < 0.1% |
| 0.02272727273 | 1 | < 0.1% |
| 0.02631578947 | 1 | < 0.1% |
| 0.02857142857 | 1 | < 0.1% |
| 0.0303030303 | 1 | < 0.1% |
| 0.03225806452 | 1 | < 0.1% |
| 0.03333333333 | 1 | < 0.1% |
| 0.03448275862 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.75 | 1 | < 0.1% |
| 0.7142857143 | 1 | < 0.1% |
| 0.6666666667 | 18 | 0.4% |
| 0.6 | 13 | 0.3% |
| 0.5714285714 | 5 | 0.1% |
| 0.5555555556 | 2 | < 0.1% |
| 0.5454545455 | 2 | < 0.1% |
| 0.5 | 234 | |
| 0.4736842105 | 1 | < 0.1% |
| 0.4615384615 | 4 | 0.1% |
avg_unt_price
Real number (ℝ)
| Distinct | 4173 |
|---|---|
| Distinct (%) | 96.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4633073 |
| Minimum | 0.1225 |
|---|---|
| Maximum | 434.65 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0.1225 |
|---|---|
| 5-th percentile | 1.3236833 |
| Q1 | 2.1573676 |
| median | 2.8290222 |
| Q3 | 3.7120688 |
| 95-th percentile | 5.9766905 |
| Maximum | 434.65 |
| Range | 434.5275 |
| Interquartile range (IQR) | 1.5547011 |
Descriptive statistics
| Standard deviation | 8.875852 |
|---|---|
| Coefficient of variation (CV) | 2.5628255 |
| Kurtosis | 1578.4644 |
| Mean | 3.4633073 |
| Median Absolute Deviation (MAD) | 0.74558104 |
| Skewness | 36.542242 |
| Sum | 14961.487 |
| Variance | 78.780749 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.06 | 10 | 0.2% |
| 1.79 | 8 | 0.2% |
| 4.95 | 7 | 0.2% |
| 2.08 | 7 | 0.2% |
| 1.25 | 6 | 0.1% |
| 2.55 | 6 | 0.1% |
| 2.95 | 6 | 0.1% |
| 12.75 | 4 | 0.1% |
| 4.25 | 4 | 0.1% |
| 0.72 | 4 | 0.1% |
| Other values (4163) | 4258 |
| Value | Count | Frequency (%) |
| 0.1225 | 1 | |
| 0.17 | 2 | |
| 0.2327777778 | 1 | |
| 0.29 | 2 | |
| 0.32 | 1 | |
| 0.358 | 1 | |
| 0.3666666667 | 1 | |
| 0.39 | 1 | |
| 0.3917241379 | 1 | |
| 0.39375 | 1 |
| Value | Count | Frequency (%) |
| 434.65 | 1 | |
| 295 | 1 | |
| 125 | 1 | |
| 110 | 2 | |
| 74.975 | 1 | |
| 66.475 | 1 | |
| 59.73333333 | 1 | |
| 54.3 | 1 | |
| 51.71 | 1 | |
| 32.97142857 | 1 |
avg_order_value
Real number (ℝ)
| Distinct | 4250 |
|---|---|
| Distinct (%) | 98.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 326.33512 |
| Minimum | 0.96666667 |
|---|---|
| Maximum | 9904.875 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 0.96666667 |
|---|---|
| 5-th percentile | 76.497444 |
| Q1 | 154.895 |
| median | 240.79536 |
| Q3 | 372.115 |
| 95-th percentile | 775.86938 |
| Maximum | 9904.875 |
| Range | 9903.9083 |
| Interquartile range (IQR) | 217.22 |
Descriptive statistics
| Standard deviation | 390.52051 |
|---|---|
| Coefficient of variation (CV) | 1.1966855 |
| Kurtosis | 136.13431 |
| Mean | 326.33512 |
| Median Absolute Deviation (MAD) | 100.78464 |
| Skewness | 8.8462255 |
| Sum | 1409767.7 |
| Variance | 152506.27 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 120 | 4 | 0.1% |
| 76.32 | 4 | 0.1% |
| 113.5 | 3 | 0.1% |
| 15 | 3 | 0.1% |
| 197.9 | 3 | 0.1% |
| 35.4 | 3 | 0.1% |
| 440 | 3 | 0.1% |
| 72 | 2 | < 0.1% |
| 142.4 | 2 | < 0.1% |
| 357.21 | 2 | < 0.1% |
| Other values (4240) | 4291 |
| Value | Count | Frequency (%) |
| 0.9666666667 | 1 | < 0.1% |
| 3.75 | 2 | |
| 5.9 | 1 | < 0.1% |
| 6.12 | 1 | < 0.1% |
| 9.14 | 1 | < 0.1% |
| 11.67 | 1 | < 0.1% |
| 12.75 | 1 | < 0.1% |
| 15 | 3 | |
| 17 | 1 | < 0.1% |
| 20.475 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9904.875 | 1 | |
| 6207.67 | 1 | |
| 5383.975 | 1 | |
| 5151.590833 | 1 | |
| 4873.81 | 1 | |
| 4669.19 | 1 | |
| 4366.78 | 1 | |
| 4327.621667 | 1 | |
| 4314.72 | 1 | |
| 4131.233333 | 1 |
gross_revenue
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 4245 |
|---|---|
| Distinct (%) | 98.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1920.743 |
| Minimum | 2.9 |
|---|---|
| Maximum | 278778.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 33.9 KiB |
Quantile statistics
| Minimum | 2.9 |
|---|---|
| 5-th percentile | 110.7975 |
| Q1 | 300.845 |
| median | 654.76 |
| Q3 | 1611.4325 |
| 95-th percentile | 5657.141 |
| Maximum | 278778.02 |
| Range | 278775.12 |
| Interquartile range (IQR) | 1310.5875 |
Descriptive statistics
| Standard deviation | 8320.8119 |
|---|---|
| Coefficient of variation (CV) | 4.3320798 |
| Kurtosis | 595.75815 |
| Mean | 1920.743 |
| Median Absolute Deviation (MAD) | 453.69 |
| Skewness | 21.507718 |
| Sum | 8297609.7 |
| Variance | 69235911 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 76.32 | 4 | 0.1% |
| 440 | 3 | 0.1% |
| 35.4 | 3 | 0.1% |
| 15 | 3 | 0.1% |
| 113.5 | 3 | 0.1% |
| 363.65 | 3 | 0.1% |
| 144 | 2 | < 0.1% |
| 161 | 2 | < 0.1% |
| 598.2 | 2 | < 0.1% |
| 248.61 | 2 | < 0.1% |
| Other values (4235) | 4293 |
| Value | Count | Frequency (%) |
| 2.9 | 1 | < 0.1% |
| 3.75 | 1 | < 0.1% |
| 5.9 | 1 | < 0.1% |
| 12.24 | 1 | < 0.1% |
| 12.75 | 1 | < 0.1% |
| 15 | 3 | |
| 17 | 1 | < 0.1% |
| 20.8 | 2 | |
| 25.5 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 278778.02 | 1 | |
| 259657.3 | 1 | |
| 189735.53 | 1 | |
| 133007.13 | 1 | |
| 123638.18 | 1 | |
| 114505.32 | 1 | |
| 88138.2 | 1 | |
| 65920.12 | 1 | |
| 62924.1 | 1 | |
| 59419.34 | 1 |
| customer_id | lifetime | recency | avg_purchase_interval | frequency | number_products | nunique_products | avg_basket_size | purchase_count | charge_back_count | return_rate | avg_unt_price | avg_order_value | gross_revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | 0.004 | 0.006 | -0.001 | 0.002 | -0.005 | -0.009 | -0.087 | -0.013 | -0.044 | -0.051 | -0.018 | -0.105 | -0.079 |
| lifetime | 0.004 | 1.000 | 0.105 | 0.287 | -0.285 | 0.344 | 0.300 | -0.053 | 0.514 | 0.307 | 0.221 | 0.094 | 0.001 | 0.398 |
| recency | 0.006 | 0.105 | 1.000 | 0.764 | -0.763 | -0.499 | -0.456 | -0.151 | -0.536 | -0.272 | -0.171 | 0.097 | -0.115 | -0.485 |
| avg_purchase_interval | -0.001 | 0.287 | 0.764 | 1.000 | -0.999 | -0.462 | -0.416 | -0.116 | -0.550 | -0.443 | -0.357 | 0.077 | -0.076 | -0.471 |
| frequency | 0.002 | -0.285 | -0.763 | -0.999 | 1.000 | 0.462 | 0.416 | 0.114 | 0.551 | 0.443 | 0.358 | -0.076 | 0.075 | 0.470 |
| number_products | -0.005 | 0.344 | -0.499 | -0.462 | 0.462 | 1.000 | 0.983 | 0.385 | 0.716 | 0.411 | 0.293 | -0.084 | 0.381 | 0.788 |
| nunique_products | -0.009 | 0.300 | -0.456 | -0.416 | 0.416 | 0.983 | 1.000 | 0.395 | 0.642 | 0.374 | 0.273 | -0.081 | 0.383 | 0.734 |
| avg_basket_size | -0.087 | -0.053 | -0.151 | -0.116 | 0.114 | 0.385 | 0.395 | 1.000 | 0.057 | -0.050 | -0.094 | -0.400 | 0.817 | 0.512 |
| purchase_count | -0.013 | 0.514 | -0.536 | -0.550 | 0.551 | 0.716 | 0.642 | 0.057 | 1.000 | 0.667 | 0.557 | 0.026 | 0.061 | 0.801 |
| charge_back_count | -0.044 | 0.307 | -0.272 | -0.443 | 0.443 | 0.411 | 0.374 | -0.050 | 0.667 | 1.000 | 0.958 | 0.080 | -0.052 | 0.482 |
| return_rate | -0.051 | 0.221 | -0.171 | -0.357 | 0.358 | 0.293 | 0.273 | -0.094 | 0.557 | 0.958 | 1.000 | 0.087 | -0.103 | 0.362 |
| avg_unt_price | -0.018 | 0.094 | 0.097 | 0.077 | -0.076 | -0.084 | -0.081 | -0.400 | 0.026 | 0.080 | 0.087 | 1.000 | 0.002 | 0.021 |
| avg_order_value | -0.105 | 0.001 | -0.115 | -0.076 | 0.075 | 0.381 | 0.383 | 0.817 | 0.061 | -0.052 | -0.103 | 0.002 | 1.000 | 0.611 |
| gross_revenue | -0.079 | 0.398 | -0.485 | -0.471 | 0.470 | 0.788 | 0.734 | 0.512 | 0.801 | 0.482 | 0.362 | 0.021 | 0.611 | 1.000 |
| customer_id | lifetime | recency | avg_purchase_interval | frequency | number_products | nunique_products | avg_basket_size | purchase_count | charge_back_count | return_rate | avg_unt_price | avg_order_value | gross_revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17850.0 | 373.0 | 372.0 | 10.657143 | 0.093834 | 297.0 | 21.0 | 48.371429 | 35 | 1.0 | 0.028571 | 3.960370 | 151.103714 | 5288.63 |
| 1 | 13047.0 | 373.0 | 56.0 | 23.312500 | 0.042895 | 171.0 | 105.0 | 84.687500 | 16 | 7.0 | 0.437500 | 3.926082 | 193.068750 | 3089.10 |
| 2 | 12583.0 | 373.0 | 2.0 | 21.941176 | 0.045576 | 232.0 | 114.0 | 292.823529 | 17 | 2.0 | 0.117647 | 2.140474 | 389.961176 | 6629.34 |
| 3 | 13748.0 | 373.0 | 95.0 | 74.600000 | 0.013405 | 28.0 | 24.0 | 87.800000 | 5 | 0.0 | 0.000000 | 3.996429 | 189.650000 | 948.25 |
| 4 | 15100.0 | 373.0 | 333.0 | 62.166667 | 0.016086 | 3.0 | 1.0 | 9.666667 | 6 | 3.0 | 0.500000 | 10.950000 | 105.850000 | 635.10 |
| 5 | 15291.0 | 373.0 | 25.0 | 19.631579 | 0.050938 | 102.0 | 61.0 | 109.105263 | 19 | 5.0 | 0.263158 | 4.702255 | 239.553158 | 4551.51 |
| 6 | 14688.0 | 373.0 | 7.0 | 13.814815 | 0.072386 | 327.0 | 148.0 | 119.333333 | 27 | 6.0 | 0.222222 | 2.131040 | 189.162222 | 5107.38 |
| 7 | 17809.0 | 373.0 | 16.0 | 26.642857 | 0.037534 | 61.0 | 46.0 | 144.000000 | 14 | 2.0 | 0.142857 | 2.905738 | 381.775000 | 5344.85 |
| 8 | 15311.0 | 373.0 | 0.0 | 3.161017 | 0.316354 | 2379.0 | 567.0 | 319.661017 | 118 | 27.0 | 0.228814 | 2.506036 | 503.553729 | 59419.34 |
| 9 | 16098.0 | 373.0 | 87.0 | 53.285714 | 0.018767 | 67.0 | 34.0 | 87.571429 | 7 | 0.0 | 0.000000 | 4.424627 | 286.518571 | 2005.63 |
| customer_id | lifetime | recency | avg_purchase_interval | frequency | number_products | nunique_products | avg_basket_size | purchase_count | charge_back_count | return_rate | avg_unt_price | avg_order_value | gross_revenue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4310 | 16000.0 | 2.0 | 2.0 | 0.666667 | 1.5 | 9.0 | 9.0 | 1703.333333 | 3 | 0.0 | 0.0 | 3.345556 | 4131.233333 | 12393.70 |
| 4311 | 15195.0 | 2.0 | 2.0 | 2.000000 | 0.5 | 1.0 | 1.0 | 1404.000000 | 1 | 0.0 | 0.0 | 2.750000 | 3861.000000 | 3861.00 |
| 4312 | 14087.0 | 2.0 | 2.0 | 1.000000 | 1.0 | 69.0 | 61.0 | 125.000000 | 2 | 1.0 | 0.5 | 1.420725 | 90.835000 | 181.67 |
| 4313 | 14204.0 | 2.0 | 2.0 | 2.000000 | 0.5 | 44.0 | 36.0 | 82.000000 | 1 | 0.0 | 0.0 | 2.405000 | 161.030000 | 161.03 |
| 4314 | 15471.0 | 2.0 | 2.0 | 2.000000 | 0.5 | 77.0 | 67.0 | 266.000000 | 1 | 0.0 | 0.0 | 1.999221 | 469.480000 | 469.48 |
| 4315 | 13436.0 | 1.0 | 1.0 | 1.000000 | 1.0 | 12.0 | 12.0 | 76.000000 | 1 | 0.0 | 0.0 | 5.830000 | 196.890000 | 196.89 |
| 4316 | 15520.0 | 1.0 | 1.0 | 1.000000 | 1.0 | 18.0 | 18.0 | 314.000000 | 1 | 0.0 | 0.0 | 1.724444 | 343.500000 | 343.50 |
| 4317 | 13298.0 | 1.0 | 1.0 | 1.000000 | 1.0 | 2.0 | 2.0 | 96.000000 | 1 | 0.0 | 0.0 | 3.750000 | 360.000000 | 360.00 |
| 4318 | 14569.0 | 1.0 | 1.0 | 1.000000 | 1.0 | 12.0 | 10.0 | 79.000000 | 1 | 0.0 | 0.0 | 3.920000 | 227.390000 | 227.39 |
| 4319 | 12713.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 37.0 | 37.0 | 505.000000 | 1 | 0.0 | 0.0 | 2.084595 | 794.550000 | 794.55 |